Tabela Contractor

Definicja tabeli Contractor

Name

Contractor

Code

Contractor

Comment

PL: Definicja kontrahenta
EN: Contractor definition


Lista kolumn tabeli Contractor

Name

Code

ContractorID

ContractorID

InsurID

InsurID

DiscountID

DiscountID

EmployerID

EmployerID

PayerGroupID

PayerGroupID

CraftID

CraftID

BranchID

BranchID

Con_ContractorID

Con_ContractorID

ExternalOrgUnitID

ExternalOrgUnitID

PersonID

PersonID

DefaultBankAccountID

DefaultBankAccountID

Code

Code

ShortName

ShortName

FullName

FullName

AccountName

AccountName

AccountNo

AccountNo

StartDT

StartDT

StopDT

StopDT

Active

Active

CompanyStatisticalNo

CompanyStatisticalNo

VATPayer

VATPayer

DebtorNo

DebtorNo

IdentificationNo

IdentificationNo

Comments

Comments

HasContracts

HasContracts

TaxPayerID

TaxPayerID

NfzServiceProviderCode

NfzServiceProviderCode


Kolumna ContractorID tabeli Contractor

Definicja kolumny ContractorID tabeli Contractor

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsurID tabeli Contractor

Definicja kolumny InsurID tabeli Contractor

Name

InsurID

Code

InsurID

Data Type

NUMBER(10)

Mandatory

No

Comment

depreciated


Kolumna DiscountID tabeli Contractor

Definicja kolumny DiscountID tabeli Contractor

Name

DiscountID

Code

DiscountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EmployerID tabeli Contractor

Definicja kolumny EmployerID tabeli Contractor

Name

EmployerID

Code

EmployerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PayerGroupID tabeli Contractor

Definicja kolumny PayerGroupID tabeli Contractor

Name

PayerGroupID

Code

PayerGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CraftID tabeli Contractor

Definicja kolumny CraftID tabeli Contractor

Name

CraftID

Code

CraftID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BranchID tabeli Contractor

Definicja kolumny BranchID tabeli Contractor

Name

BranchID

Code

BranchID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Con_ContractorID tabeli Contractor

Definicja kolumny Con_ContractorID tabeli Contractor

Name

Con_ContractorID

Code

Con_ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalOrgUnitID tabeli Contractor

Definicja kolumny ExternalOrgUnitID tabeli Contractor

Name

ExternalOrgUnitID

Code

ExternalOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli Contractor

Definicja kolumny PersonID tabeli Contractor

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DefaultBankAccountID tabeli Contractor

Definicja kolumny DefaultBankAccountID tabeli Contractor

Name

DefaultBankAccountID

Code

DefaultBankAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

Domyslne konto bankowe sprzedawcy


Kolumna Code tabeli Contractor

Definicja kolumny Code tabeli Contractor

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli Contractor

Definicja kolumny ShortName tabeli Contractor

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli Contractor

Definicja kolumny FullName tabeli Contractor

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna AccountName tabeli Contractor

Definicja kolumny AccountName tabeli Contractor

Name

AccountName

Code

AccountName

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna AccountNo tabeli Contractor

Definicja kolumny AccountNo tabeli Contractor

Name

AccountNo

Code

AccountNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Contractor

Definicja kolumny StartDT tabeli Contractor

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Contractor

Definicja kolumny StopDT tabeli Contractor

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli Contractor

Definicja kolumny Active tabeli Contractor

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna CompanyStatisticalNo tabeli Contractor

Definicja kolumny CompanyStatisticalNo tabeli Contractor

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna VATPayer tabeli Contractor

Definicja kolumny VATPayer tabeli Contractor

Name

VATPayer

Code

VATPayer

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna DebtorNo tabeli Contractor

Definicja kolumny DebtorNo tabeli Contractor

Name

DebtorNo

Code

DebtorNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna IdentificationNo tabeli Contractor

Definicja kolumny IdentificationNo tabeli Contractor

Name

IdentificationNo

Code

IdentificationNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna Comments tabeli Contractor

Definicja kolumny Comments tabeli Contractor

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna HasContracts tabeli Contractor

Definicja kolumny HasContracts tabeli Contractor

Name

HasContracts

Code

HasContracts

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna TaxPayerID tabeli Contractor

Definicja kolumny TaxPayerID tabeli Contractor

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna NfzServiceProviderCode tabeli Contractor

Definicja kolumny NfzServiceProviderCode tabeli Contractor

Name

NfzServiceProviderCode

Code

NfzServiceProviderCode

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Kod swiadczeniodawcy nadawany przez NFZ


Lista kluczy tabeli Contractor

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Contractor

Definicja klucza Identifier_1 tabeli Contractor

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment